/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: 17655
 * Date: 2025-03-13
 * Time: 14:03
 */
public class test12 {
    /**
     * LeetCode 1280
     */

    /**
    解析：要查考了多少次，学生id要，学生名称要，课程名称要，课程出现的次数要count   连接3个表
     cross join   left join
     group by 与 count搭配使用，根据什么来计算次数
     order by 进行排序
     */

    /*
    select st.student_id,st.student_name,su.subject_name,count(e.subject_name) as attended_exams
    from Students st cross join Subjects su left join Examinations e
    on e.student_id = st.student_id and e.subject_name = su.subject_name
    group by st.student_id,su.subject_name
    order by st.student_id,su.subject_name;
     */
}
